package BoostedTest::RDBO::Testcase;

use strict;

use base qw(BoostedTest::RDBO::DB::Object);

__PACKAGE__->meta->setup(
    table   => 'testcases',

    columns => [
        id            => { type => 'serial', not_null => 1 },
        testplans_id  => { type => 'integer', default => '0', not_null => 1 },
        testId        => { type => 'varchar', default => '', length => 255, not_null => 1 },
        priority      => { type => 'integer' },
        purpose       => { type => 'varchar', length => 255 },
        expected      => { type => 'scalar', length => 16777215 },
        steps         => { type => 'scalar', default => '', length => 16777215, not_null => 1 },
        special_notes => { type => 'scalar', default => '', length => 16777215, not_null => 1 },
        automated     => { type => 'varchar', length => 15 },
        modified      => { type => 'datetime' },
        created       => { type => 'datetime' },
    ],

    foreign_keys =>
    [
      testplan =>
      {
        class       => 'BoostedTest::RDBO::Testplans',
        key_columns => { testplans_id => 'id' },
      },

    ],

    primary_key_columns => [ 'id' ],
);

1;

